Dataset statistics
| Number of variables | 31 |
|---|---|
| Number of observations | 40060 |
| Missing cells | 464 |
| Missing cells (%) | < 0.1% |
| Duplicate rows | 2325 |
| Duplicate rows (%) | 5.8% |
| Total size in memory | 9.5 MiB |
| Average record size in memory | 248.0 B |
Variable types
| Categorical | 19 |
|---|---|
| Numeric | 12 |
| Dataset has 2325 (5.8%) duplicate rows | Duplicates |
Country has a high cardinality: 125 distinct values | High cardinality |
Agent has a high cardinality: 186 distinct values | High cardinality |
Company has a high cardinality: 236 distinct values | High cardinality |
ReservationStatusDate has a high cardinality: 913 distinct values | High cardinality |
LeadTime is highly overall correlated with StaysInWeekNights | High correlation |
ArrivalDateWeekNumber is highly overall correlated with ArrivalDateMonth | High correlation |
StaysInWeekendNights is highly overall correlated with StaysInWeekNights | High correlation |
StaysInWeekNights is highly overall correlated with LeadTime and 1 other fields | High correlation |
IsCanceled is highly overall correlated with ReservationStatus | High correlation |
ArrivalDateMonth is highly overall correlated with ArrivalDateWeekNumber | High correlation |
MarketSegment is highly overall correlated with DistributionChannel | High correlation |
DistributionChannel is highly overall correlated with MarketSegment | High correlation |
ReservedRoomType is highly overall correlated with AssignedRoomType | High correlation |
AssignedRoomType is highly overall correlated with ReservedRoomType | High correlation |
ReservationStatus is highly overall correlated with IsCanceled | High correlation |
Children is highly imbalanced (77.7%) | Imbalance |
Babies is highly imbalanced (93.3%) | Imbalance |
Meal is highly imbalanced (54.6%) | Imbalance |
Country is highly imbalanced (56.6%) | Imbalance |
IsRepeatedGuest is highly imbalanced (73.8%) | Imbalance |
DepositType is highly imbalanced (81.8%) | Imbalance |
Company is highly imbalanced (89.4%) | Imbalance |
RequiredCarParkingSpaces is highly imbalanced (74.9%) | Imbalance |
Country has 464 (1.2%) missing values | Missing |
Adults is highly skewed (γ1 = 31.61075868) | Skewed |
LeadTime has 3236 (8.1%) zeros | Zeros |
StaysInWeekendNights has 14181 (35.4%) zeros | Zeros |
StaysInWeekNights has 2682 (6.7%) zeros | Zeros |
PreviousCancellations has 38965 (97.3%) zeros | Zeros |
PreviousBookingsNotCanceled has 38028 (94.9%) zeros | Zeros |
BookingChanges has 32252 (80.5%) zeros | Zeros |
DaysInWaitingList has 39805 (99.4%) zeros | Zeros |
ADR has 751 (1.9%) zeros | Zeros |
TotalOfSpecialRequests has 22361 (55.8%) zeros | Zeros |
Reproduction
| Analysis started | 2023-11-24 17:45:29.492562 |
|---|---|
| Analysis finished | 2023-11-24 17:45:42.476873 |
| Duration | 12.98 seconds |
| Software version | ydata-profiling v0.0.dev0 |
| Download configuration | config.json |
IsCanceled
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 313.1 KiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 40060 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 28938 | |
| 1 | 11122 | 27.8% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 28938 | |
| 1 | 11122 | 27.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 28938 | |
| 1 | 11122 | 27.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 40060 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 28938 | |
| 1 | 11122 | 27.8% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 40060 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 28938 | |
| 1 | 11122 | 27.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 40060 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 28938 | |
| 1 | 11122 | 27.8% |
LeadTime
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 412 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 92.675686 |
| Minimum | 0 |
|---|---|
| Maximum | 737 |
| Zeros | 3236 |
| Zeros (%) | 8.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 313.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 10 |
| median | 57 |
| Q3 | 155 |
| 95-th percentile | 287 |
| Maximum | 737 |
| Range | 737 |
| Interquartile range (IQR) | 145 |
Descriptive statistics
| Standard deviation | 97.285315 |
|---|---|
| Coefficient of variation (CV) | 1.0497394 |
| Kurtosis | 0.71548823 |
| Mean | 92.675686 |
| Median Absolute Deviation (MAD) | 54 |
| Skewness | 1.1327159 |
| Sum | 3712588 |
| Variance | 9464.4326 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 3236 | 8.1% |
| 1 | 1595 | 4.0% |
| 2 | 939 | 2.3% |
| 3 | 794 | 2.0% |
| 4 | 663 | 1.7% |
| 5 | 600 | 1.5% |
| 7 | 573 | 1.4% |
| 6 | 538 | 1.3% |
| 10 | 391 | 1.0% |
| 8 | 388 | 1.0% |
| Other values (402) | 30343 |
| Value | Count | Frequency (%) |
| 0 | 3236 | |
| 1 | 1595 | |
| 2 | 939 | 2.3% |
| 3 | 794 | 2.0% |
| 4 | 663 | 1.7% |
| 5 | 600 | 1.5% |
| 6 | 538 | 1.3% |
| 7 | 573 | 1.4% |
| 8 | 388 | 1.0% |
| 9 | 368 | 0.9% |
| Value | Count | Frequency (%) |
| 737 | 1 | < 0.1% |
| 709 | 1 | < 0.1% |
| 542 | 23 | |
| 532 | 1 | < 0.1% |
| 471 | 6 | < 0.1% |
| 468 | 47 | |
| 462 | 20 | |
| 460 | 3 | < 0.1% |
| 454 | 1 | < 0.1% |
| 450 | 1 | < 0.1% |
ArrivalDateYear
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 313.1 KiB |
| 2016 | |
|---|---|
| 2017 | |
| 2015 |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Characters and Unicode
| Total characters | 160240 |
|---|---|
| Distinct characters | 6 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2015 |
|---|---|
| 2nd row | 2015 |
| 3rd row | 2015 |
| 4th row | 2015 |
| 5th row | 2015 |
Common Values
| Value | Count | Frequency (%) |
| 2016 | 18567 | |
| 2017 | 13179 | |
| 2015 | 8314 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2016 | 18567 | |
| 2017 | 13179 | |
| 2015 | 8314 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 40060 | |
| 0 | 40060 | |
| 1 | 40060 | |
| 6 | 18567 | |
| 7 | 13179 | 8.2% |
| 5 | 8314 | 5.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 160240 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 40060 | |
| 0 | 40060 | |
| 1 | 40060 | |
| 6 | 18567 | |
| 7 | 13179 | 8.2% |
| 5 | 8314 | 5.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 160240 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 40060 | |
| 0 | 40060 | |
| 1 | 40060 | |
| 6 | 18567 | |
| 7 | 13179 | 8.2% |
| 5 | 8314 | 5.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 160240 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 40060 | |
| 0 | 40060 | |
| 1 | 40060 | |
| 6 | 18567 | |
| 7 | 13179 | 8.2% |
| 5 | 8314 | 5.2% |
ArrivalDateMonth
Categorical
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 313.1 KiB |
| August | |
|---|---|
| July | |
| April | |
| May | |
| October | |
| Other values (7) |
Length
| Max length | 9 |
|---|---|
| Median length | 7 |
| Mean length | 5.9648028 |
| Min length | 3 |
Characters and Unicode
| Total characters | 238950 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | July |
|---|---|
| 2nd row | July |
| 3rd row | July |
| 4th row | July |
| 5th row | July |
Common Values
| Value | Count | Frequency (%) |
| August | 4894 | |
| July | 4573 | |
| April | 3609 | |
| May | 3559 | |
| October | 3555 | |
| March | 3336 | |
| September | 3108 | |
| February | 3103 | |
| June | 3045 | |
| December | 2648 | |
| Other values (2) | 4630 |
Length
| Value | Count | Frequency (%) |
| august | 4894 | |
| july | 4573 | |
| april | 3609 | |
| may | 3559 | |
| october | 3555 | |
| march | 3336 | |
| september | 3108 | |
| february | 3103 | |
| june | 3045 | |
| december | 2648 | |
| Other values (2) | 4630 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 31845 | |
| r | 27092 | 11.3% |
| u | 22702 | 9.5% |
| b | 14851 | 6.2% |
| a | 14384 | 6.0% |
| y | 13428 | 5.6% |
| t | 11557 | 4.8% |
| J | 9811 | 4.1% |
| c | 9539 | 4.0% |
| A | 8503 | 3.6% |
| Other values (16) | 75238 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 198890 | |
| Uppercase Letter | 40060 | 16.8% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 31845 | |
| r | 27092 | |
| u | 22702 | |
| b | 14851 | |
| a | 14384 | 7.2% |
| y | 13428 | 6.8% |
| t | 11557 | 5.8% |
| c | 9539 | 4.8% |
| m | 8193 | 4.1% |
| l | 8182 | 4.1% |
| Other values (8) | 37117 |
Uppercase Letter
| Value | Count | Frequency (%) |
| J | 9811 | |
| A | 8503 | |
| M | 6895 | |
| O | 3555 | 8.9% |
| S | 3108 | 7.8% |
| F | 3103 | 7.7% |
| D | 2648 | 6.6% |
| N | 2437 | 6.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 238950 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 31845 | |
| r | 27092 | 11.3% |
| u | 22702 | 9.5% |
| b | 14851 | 6.2% |
| a | 14384 | 6.0% |
| y | 13428 | 5.6% |
| t | 11557 | 4.8% |
| J | 9811 | 4.1% |
| c | 9539 | 4.0% |
| A | 8503 | 3.6% |
| Other values (16) | 75238 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 238950 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 31845 | |
| r | 27092 | 11.3% |
| u | 22702 | 9.5% |
| b | 14851 | 6.2% |
| a | 14384 | 6.0% |
| y | 13428 | 5.6% |
| t | 11557 | 4.8% |
| J | 9811 | 4.1% |
| c | 9539 | 4.0% |
| A | 8503 | 3.6% |
| Other values (16) | 75238 |
ArrivalDateWeekNumber
Real number (ℝ)
| Distinct | 53 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 27.140864 |
| Minimum | 1 |
|---|---|
| Maximum | 53 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 313.1 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 16 |
| median | 28 |
| Q3 | 38 |
| 95-th percentile | 50 |
| Maximum | 53 |
| Range | 52 |
| Interquartile range (IQR) | 22 |
Descriptive statistics
| Standard deviation | 14.005441 |
|---|---|
| Coefficient of variation (CV) | 0.51602783 |
| Kurtosis | -1.0320734 |
| Mean | 27.140864 |
| Median Absolute Deviation (MAD) | 11 |
| Skewness | -0.010016716 |
| Sum | 1087263 |
| Variance | 196.15238 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 33 | 1197 | 3.0% |
| 31 | 1101 | 2.7% |
| 34 | 1090 | 2.7% |
| 30 | 1076 | 2.7% |
| 32 | 1054 | 2.6% |
| 29 | 1037 | 2.6% |
| 18 | 1012 | 2.5% |
| 28 | 988 | 2.5% |
| 35 | 951 | 2.4% |
| 43 | 917 | 2.3% |
| Other values (43) | 29637 |
| Value | Count | Frequency (%) |
| 1 | 343 | 0.9% |
| 2 | 457 | |
| 3 | 553 | |
| 4 | 519 | |
| 5 | 501 | |
| 6 | 682 | |
| 7 | 904 | |
| 8 | 719 | |
| 9 | 795 | |
| 10 | 727 |
| Value | Count | Frequency (%) |
| 53 | 618 | |
| 52 | 592 | |
| 51 | 430 | |
| 50 | 449 | |
| 49 | 716 | |
| 48 | 493 | |
| 47 | 708 | |
| 46 | 514 | |
| 45 | 690 | |
| 44 | 726 |
ArrivalDateDayOfMonth
Real number (ℝ)
| Distinct | 31 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.821243 |
| Minimum | 1 |
|---|---|
| Maximum | 31 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 313.1 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 8 |
| median | 16 |
| Q3 | 24 |
| 95-th percentile | 30 |
| Maximum | 31 |
| Range | 30 |
| Interquartile range (IQR) | 16 |
Descriptive statistics
| Standard deviation | 8.8837079 |
|---|---|
| Coefficient of variation (CV) | 0.56150505 |
| Kurtosis | -1.1991534 |
| Mean | 15.821243 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 0.0063741858 |
| Sum | 633799 |
| Variance | 78.920266 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 12 | 1577 | 3.9% |
| 30 | 1473 | 3.7% |
| 5 | 1460 | 3.6% |
| 16 | 1426 | 3.6% |
| 9 | 1404 | 3.5% |
| 26 | 1399 | 3.5% |
| 17 | 1394 | 3.5% |
| 2 | 1388 | 3.5% |
| 18 | 1378 | 3.4% |
| 24 | 1370 | 3.4% |
| Other values (21) | 25791 |
| Value | Count | Frequency (%) |
| 1 | 1294 | |
| 2 | 1388 | |
| 3 | 1325 | |
| 4 | 1302 | |
| 5 | 1460 | |
| 6 | 1192 | |
| 7 | 1206 | |
| 8 | 1245 | |
| 9 | 1404 | |
| 10 | 1185 |
| Value | Count | Frequency (%) |
| 31 | 856 | |
| 30 | 1473 | |
| 29 | 1214 | |
| 28 | 1276 | |
| 27 | 1265 | |
| 26 | 1399 | |
| 25 | 1337 | |
| 24 | 1370 | |
| 23 | 1169 | |
| 22 | 1270 |
StaysInWeekendNights
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 16 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.1898153 |
| Minimum | 0 |
|---|---|
| Maximum | 19 |
| Zeros | 14181 |
| Zeros (%) | 35.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 313.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 3 |
| Maximum | 19 |
| Range | 19 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.1478122 |
|---|---|
| Coefficient of variation (CV) | 0.96469782 |
| Kurtosis | 7.5634483 |
| Mean | 1.1898153 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 1.3925394 |
| Sum | 47664 |
| Variance | 1.3174728 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 14181 | |
| 2 | 13975 | |
| 1 | 9192 | |
| 4 | 1558 | 3.9% |
| 3 | 936 | 2.3% |
| 6 | 113 | 0.3% |
| 8 | 36 | 0.1% |
| 5 | 35 | 0.1% |
| 7 | 13 | < 0.1% |
| 12 | 5 | < 0.1% |
| Other values (6) | 16 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 14181 | |
| 1 | 9192 | |
| 2 | 13975 | |
| 3 | 936 | 2.3% |
| 4 | 1558 | 3.9% |
| 5 | 35 | 0.1% |
| 6 | 113 | 0.3% |
| 7 | 13 | < 0.1% |
| 8 | 36 | 0.1% |
| 9 | 5 | < 0.1% |
| Value | Count | Frequency (%) |
| 19 | 1 | < 0.1% |
| 18 | 1 | < 0.1% |
| 16 | 2 | < 0.1% |
| 13 | 2 | < 0.1% |
| 12 | 5 | < 0.1% |
| 10 | 5 | < 0.1% |
| 9 | 5 | < 0.1% |
| 8 | 36 | 0.1% |
| 7 | 13 | < 0.1% |
| 6 | 113 |
StaysInWeekNights
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 31 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.1287319 |
| Minimum | 0 |
|---|---|
| Maximum | 50 |
| Zeros | 2682 |
| Zeros (%) | 6.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 313.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 3 |
| Q3 | 5 |
| 95-th percentile | 7 |
| Maximum | 50 |
| Range | 50 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 2.4613294 |
|---|---|
| Coefficient of variation (CV) | 0.78668594 |
| Kurtosis | 15.627246 |
| Mean | 3.1287319 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 2.2526292 |
| Sum | 125337 |
| Variance | 6.0581425 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 9222 | |
| 5 | 7811 | |
| 2 | 7281 | |
| 3 | 5887 | |
| 4 | 3422 | 8.5% |
| 0 | 2682 | 6.7% |
| 6 | 1120 | 2.8% |
| 10 | 891 | 2.2% |
| 7 | 828 | 2.1% |
| 8 | 496 | 1.2% |
| Other values (21) | 420 | 1.0% |
| Value | Count | Frequency (%) |
| 0 | 2682 | 6.7% |
| 1 | 9222 | |
| 2 | 7281 | |
| 3 | 5887 | |
| 4 | 3422 | 8.5% |
| 5 | 7811 | |
| 6 | 1120 | 2.8% |
| 7 | 828 | 2.1% |
| 8 | 496 | 1.2% |
| 9 | 158 | 0.4% |
| Value | Count | Frequency (%) |
| 50 | 1 | < 0.1% |
| 42 | 1 | < 0.1% |
| 40 | 2 | < 0.1% |
| 33 | 1 | < 0.1% |
| 32 | 1 | < 0.1% |
| 30 | 4 | |
| 26 | 1 | < 0.1% |
| 25 | 5 | |
| 24 | 1 | < 0.1% |
| 22 | 1 | < 0.1% |
Adults
Real number (ℝ)
| Distinct | 14 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.8671493 |
| Minimum | 0 |
|---|---|
| Maximum | 55 |
| Zeros | 13 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 313.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 2 |
| Q3 | 2 |
| 95-th percentile | 2 |
| Maximum | 55 |
| Range | 55 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.69728549 |
|---|---|
| Coefficient of variation (CV) | 0.37344925 |
| Kurtosis | 1916.4281 |
| Mean | 1.8671493 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 31.610759 |
| Sum | 74798 |
| Variance | 0.48620706 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2 | 31425 | |
| 1 | 7148 | 17.8% |
| 3 | 1427 | 3.6% |
| 4 | 31 | 0.1% |
| 0 | 13 | < 0.1% |
| 26 | 5 | < 0.1% |
| 27 | 2 | < 0.1% |
| 20 | 2 | < 0.1% |
| 5 | 2 | < 0.1% |
| 40 | 1 | < 0.1% |
| Other values (4) | 4 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 13 | < 0.1% |
| 1 | 7148 | 17.8% |
| 2 | 31425 | |
| 3 | 1427 | 3.6% |
| 4 | 31 | 0.1% |
| 5 | 2 | < 0.1% |
| 6 | 1 | < 0.1% |
| 10 | 1 | < 0.1% |
| 20 | 2 | < 0.1% |
| 26 | 5 | < 0.1% |
| Value | Count | Frequency (%) |
| 55 | 1 | < 0.1% |
| 50 | 1 | < 0.1% |
| 40 | 1 | < 0.1% |
| 27 | 2 | < 0.1% |
| 26 | 5 | < 0.1% |
| 20 | 2 | < 0.1% |
| 10 | 1 | < 0.1% |
| 6 | 1 | < 0.1% |
| 5 | 2 | < 0.1% |
| 4 | 31 |
Children
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 313.1 KiB |
| 0 | |
|---|---|
| 1 | 1838 |
| 2 | 1628 |
| 3 | 17 |
| 10 | 1 |
Length
| Max length | 2 |
|---|---|
| Median length | 1 |
| Mean length | 1.000025 |
| Min length | 1 |
Characters and Unicode
| Total characters | 40061 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 36576 | |
| 1 | 1838 | 4.6% |
| 2 | 1628 | 4.1% |
| 3 | 17 | < 0.1% |
| 10 | 1 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 36576 | |
| 1 | 1838 | 4.6% |
| 2 | 1628 | 4.1% |
| 3 | 17 | < 0.1% |
| 10 | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 36577 | |
| 1 | 1839 | 4.6% |
| 2 | 1628 | 4.1% |
| 3 | 17 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 40061 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 36577 | |
| 1 | 1839 | 4.6% |
| 2 | 1628 | 4.1% |
| 3 | 17 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 40061 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 36577 | |
| 1 | 1839 | 4.6% |
| 2 | 1628 | 4.1% |
| 3 | 17 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 40061 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 36577 | |
| 1 | 1839 | 4.6% |
| 2 | 1628 | 4.1% |
| 3 | 17 | < 0.1% |
Babies
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 313.1 KiB |
| 0 | |
|---|---|
| 1 | 539 |
| 2 | 9 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 40060 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 39512 | |
| 1 | 539 | 1.3% |
| 2 | 9 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 39512 | |
| 1 | 539 | 1.3% |
| 2 | 9 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 39512 | |
| 1 | 539 | 1.3% |
| 2 | 9 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 40060 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 39512 | |
| 1 | 539 | 1.3% |
| 2 | 9 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 40060 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 39512 | |
| 1 | 539 | 1.3% |
| 2 | 9 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 40060 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 39512 | |
| 1 | 539 | 1.3% |
| 2 | 9 | < 0.1% |
Meal
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 313.1 KiB |
| BB | |
|---|---|
| HB | |
| Undefined | 1169 |
| FB | 754 |
| SC | 86 |
Length
| Max length | 9 |
|---|---|
| Median length | 9 |
| Mean length | 9 |
| Min length | 9 |
Characters and Unicode
| Total characters | 360540 |
|---|---|
| Distinct characters | 12 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | BB |
|---|---|
| 2nd row | BB |
| 3rd row | BB |
| 4th row | BB |
| 5th row | BB |
Common Values
| Value | Count | Frequency (%) |
| BB | 30005 | |
| HB | 8046 | 20.1% |
| Undefined | 1169 | 2.9% |
| FB | 754 | 1.9% |
| SC | 86 | 0.2% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| bb | 30005 | |
| hb | 8046 | 20.1% |
| undefined | 1169 | 2.9% |
| fb | 754 | 1.9% |
| sc | 86 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| 272237 | ||
| B | 68810 | 19.1% |
| H | 8046 | 2.2% |
| n | 2338 | 0.6% |
| d | 2338 | 0.6% |
| e | 2338 | 0.6% |
| U | 1169 | 0.3% |
| f | 1169 | 0.3% |
| i | 1169 | 0.3% |
| F | 754 | 0.2% |
| Other values (2) | 172 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Space Separator | 272237 | |
| Uppercase Letter | 78951 | 21.9% |
| Lowercase Letter | 9352 | 2.6% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| B | 68810 | |
| H | 8046 | 10.2% |
| U | 1169 | 1.5% |
| F | 754 | 1.0% |
| S | 86 | 0.1% |
| C | 86 | 0.1% |
Lowercase Letter
| Value | Count | Frequency (%) |
| n | 2338 | |
| d | 2338 | |
| e | 2338 | |
| f | 1169 | |
| i | 1169 |
Space Separator
| Value | Count | Frequency (%) |
| 272237 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 272237 | |
| Latin | 88303 | 24.5% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| B | 68810 | |
| H | 8046 | 9.1% |
| n | 2338 | 2.6% |
| d | 2338 | 2.6% |
| e | 2338 | 2.6% |
| U | 1169 | 1.3% |
| f | 1169 | 1.3% |
| i | 1169 | 1.3% |
| F | 754 | 0.9% |
| S | 86 | 0.1% |
Common
| Value | Count | Frequency (%) |
| 272237 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 360540 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 272237 | ||
| B | 68810 | 19.1% |
| H | 8046 | 2.2% |
| n | 2338 | 0.6% |
| d | 2338 | 0.6% |
| e | 2338 | 0.6% |
| U | 1169 | 0.3% |
| f | 1169 | 0.3% |
| i | 1169 | 0.3% |
| F | 754 | 0.2% |
| Other values (2) | 172 | < 0.1% |
Country
Categorical
HIGH CARDINALITY  IMBALANCE  MISSING 
| Distinct | 125 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 464 |
| Missing (%) | 1.2% |
| Memory size | 313.1 KiB |
| PRT | |
|---|---|
| GBR | |
| ESP | |
| IRL | |
| FRA | 1611 |
| Other values (120) |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 2.9820689 |
| Min length | 2 |
Characters and Unicode
| Total characters | 118078 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 30 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | PRT |
|---|---|
| 2nd row | PRT |
| 3rd row | GBR |
| 4th row | GBR |
| 5th row | GBR |
Common Values
| Value | Count | Frequency (%) |
| PRT | 17630 | |
| GBR | 6814 | 17.0% |
| ESP | 3957 | 9.9% |
| IRL | 2166 | 5.4% |
| FRA | 1611 | 4.0% |
| DEU | 1203 | 3.0% |
| CN | 710 | 1.8% |
| NLD | 514 | 1.3% |
| USA | 479 | 1.2% |
| ITA | 459 | 1.1% |
| Other values (115) | 4053 | 10.1% |
| (Missing) | 464 | 1.2% |
Length
| Value | Count | Frequency (%) |
| prt | 17630 | |
| gbr | 6814 | 17.2% |
| esp | 3957 | 10.0% |
| irl | 2166 | 5.5% |
| fra | 1611 | 4.1% |
| deu | 1203 | 3.0% |
| cn | 710 | 1.8% |
| nld | 514 | 1.3% |
| usa | 479 | 1.2% |
| ita | 459 | 1.2% |
| Other values (115) | 4053 | 10.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| R | 29444 | |
| P | 21978 | |
| T | 18427 | |
| B | 7744 | 6.6% |
| G | 6958 | 5.9% |
| E | 6451 | 5.5% |
| S | 5138 | 4.4% |
| L | 3710 | 3.1% |
| A | 3558 | 3.0% |
| I | 2889 | 2.4% |
| Other values (16) | 11781 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 118078 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| R | 29444 | |
| P | 21978 | |
| T | 18427 | |
| B | 7744 | 6.6% |
| G | 6958 | 5.9% |
| E | 6451 | 5.5% |
| S | 5138 | 4.4% |
| L | 3710 | 3.1% |
| A | 3558 | 3.0% |
| I | 2889 | 2.4% |
| Other values (16) | 11781 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 118078 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| R | 29444 | |
| P | 21978 | |
| T | 18427 | |
| B | 7744 | 6.6% |
| G | 6958 | 5.9% |
| E | 6451 | 5.5% |
| S | 5138 | 4.4% |
| L | 3710 | 3.1% |
| A | 3558 | 3.0% |
| I | 2889 | 2.4% |
| Other values (16) | 11781 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 118078 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| R | 29444 | |
| P | 21978 | |
| T | 18427 | |
| B | 7744 | 6.6% |
| G | 6958 | 5.9% |
| E | 6451 | 5.5% |
| S | 5138 | 4.4% |
| L | 3710 | 3.1% |
| A | 3558 | 3.0% |
| I | 2889 | 2.4% |
| Other values (16) | 11781 |
MarketSegment
Categorical
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 313.1 KiB |
| Online TA | |
|---|---|
| Offline TA/TO | |
| Direct | |
| Groups | |
| Corporate |
Length
| Max length | 13 |
|---|---|
| Median length | 9 |
| Mean length | 8.841363 |
| Min length | 6 |
Characters and Unicode
| Total characters | 354185 |
|---|---|
| Distinct characters | 23 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Direct |
|---|---|
| 2nd row | Direct |
| 3rd row | Direct |
| 4th row | Corporate |
| 5th row | Online TA |
Common Values
| Value | Count | Frequency (%) |
| Online TA | 17729 | |
| Offline TA/TO | 7472 | |
| Direct | 6513 | 16.3% |
| Groups | 5836 | 14.6% |
| Corporate | 2309 | 5.8% |
| Complementary | 201 | 0.5% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| online | 17729 | |
| ta | 17729 | |
| offline | 7472 | |
| ta/to | 7472 | |
| direct | 6513 | 10.0% |
| groups | 5836 | 8.9% |
| corporate | 2309 | 3.5% |
| complementary | 201 | 0.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 43131 | |
| e | 34425 | |
| O | 32673 | |
| T | 32673 | |
| i | 31714 | |
| l | 25402 | 7.2% |
| 25201 | 7.1% | |
| A | 25201 | 7.1% |
| r | 17168 | 4.8% |
| f | 14944 | 4.2% |
| Other values (13) | 71653 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 216106 | |
| Uppercase Letter | 105406 | |
| Space Separator | 25201 | 7.1% |
| Other Punctuation | 7472 | 2.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| n | 43131 | |
| e | 34425 | |
| i | 31714 | |
| l | 25402 | |
| r | 17168 | 7.9% |
| f | 14944 | 6.9% |
| o | 10655 | 4.9% |
| t | 9023 | 4.2% |
| p | 8346 | 3.9% |
| c | 6513 | 3.0% |
| Other values (5) | 14785 | 6.8% |
Uppercase Letter
| Value | Count | Frequency (%) |
| O | 32673 | |
| T | 32673 | |
| A | 25201 | |
| D | 6513 | 6.2% |
| G | 5836 | 5.5% |
| C | 2510 | 2.4% |
Space Separator
| Value | Count | Frequency (%) |
| 25201 |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 7472 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 321512 | |
| Common | 32673 | 9.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| n | 43131 | |
| e | 34425 | |
| O | 32673 | |
| T | 32673 | |
| i | 31714 | |
| l | 25402 | |
| A | 25201 | |
| r | 17168 | 5.3% |
| f | 14944 | 4.6% |
| o | 10655 | 3.3% |
| Other values (11) | 53526 |
Common
| Value | Count | Frequency (%) |
| 25201 | ||
| / | 7472 | 22.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 354185 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| n | 43131 | |
| e | 34425 | |
| O | 32673 | |
| T | 32673 | |
| i | 31714 | |
| l | 25402 | 7.2% |
| 25201 | 7.1% | |
| A | 25201 | 7.1% |
| r | 17168 | 4.8% |
| f | 14944 | 4.2% |
| Other values (13) | 71653 |
DistributionChannel
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 313.1 KiB |
| TA/TO | |
|---|---|
| Direct | |
| Corporate | |
| Undefined | 1 |
Length
| Max length | 9 |
|---|---|
| Median length | 5 |
| Mean length | 5.5228407 |
| Min length | 5 |
Characters and Unicode
| Total characters | 221245 |
|---|---|
| Distinct characters | 18 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Direct |
|---|---|
| 2nd row | Direct |
| 3rd row | Direct |
| 4th row | Corporate |
| 5th row | TA/TO |
Common Values
| Value | Count | Frequency (%) |
| TA/TO | 28925 | |
| Direct | 7865 | 19.6% |
| Corporate | 3269 | 8.2% |
| Undefined | 1 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| ta/to | 28925 | |
| direct | 7865 | 19.6% |
| corporate | 3269 | 8.2% |
| undefined | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| T | 57850 | |
| / | 28925 | |
| O | 28925 | |
| A | 28925 | |
| r | 14403 | 6.5% |
| e | 11136 | 5.0% |
| t | 11134 | 5.0% |
| i | 7866 | 3.6% |
| c | 7865 | 3.6% |
| D | 7865 | 3.6% |
| Other values (8) | 16351 | 7.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 126835 | |
| Lowercase Letter | 65485 | |
| Other Punctuation | 28925 | 13.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| r | 14403 | |
| e | 11136 | |
| t | 11134 | |
| i | 7866 | |
| c | 7865 | |
| o | 6538 | |
| p | 3269 | 5.0% |
| a | 3269 | 5.0% |
| n | 2 | < 0.1% |
| d | 2 | < 0.1% |
Uppercase Letter
| Value | Count | Frequency (%) |
| T | 57850 | |
| O | 28925 | |
| A | 28925 | |
| D | 7865 | 6.2% |
| C | 3269 | 2.6% |
| U | 1 | < 0.1% |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 28925 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 192320 | |
| Common | 28925 | 13.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| T | 57850 | |
| O | 28925 | |
| A | 28925 | |
| r | 14403 | 7.5% |
| e | 11136 | 5.8% |
| t | 11134 | 5.8% |
| i | 7866 | 4.1% |
| c | 7865 | 4.1% |
| D | 7865 | 4.1% |
| o | 6538 | 3.4% |
| Other values (7) | 9813 | 5.1% |
Common
| Value | Count | Frequency (%) |
| / | 28925 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 221245 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| T | 57850 | |
| / | 28925 | |
| O | 28925 | |
| A | 28925 | |
| r | 14403 | 6.5% |
| e | 11136 | 5.0% |
| t | 11134 | 5.0% |
| i | 7866 | 3.6% |
| c | 7865 | 3.6% |
| D | 7865 | 3.6% |
| Other values (8) | 16351 | 7.4% |
IsRepeatedGuest
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 313.1 KiB |
| 0 | |
|---|---|
| 1 | 1778 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 40060 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 38282 | |
| 1 | 1778 | 4.4% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 38282 | |
| 1 | 1778 | 4.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 38282 | |
| 1 | 1778 | 4.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 40060 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 38282 | |
| 1 | 1778 | 4.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 40060 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 38282 | |
| 1 | 1778 | 4.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 40060 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 38282 | |
| 1 | 1778 | 4.4% |
PreviousCancellations
Real number (ℝ)
| Distinct | 11 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.10172242 |
| Minimum | 0 |
|---|---|
| Maximum | 26 |
| Zeros | 38965 |
| Zeros (%) | 97.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 313.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 26 |
| Range | 26 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1.3351153 |
|---|---|
| Coefficient of variation (CV) | 13.125084 |
| Kurtosis | 310.61435 |
| Mean | 0.10172242 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 17.417627 |
| Sum | 4075 |
| Variance | 1.7825328 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 38965 | |
| 1 | 896 | 2.2% |
| 24 | 48 | 0.1% |
| 2 | 44 | 0.1% |
| 26 | 26 | 0.1% |
| 25 | 25 | 0.1% |
| 19 | 19 | < 0.1% |
| 3 | 14 | < 0.1% |
| 14 | 14 | < 0.1% |
| 4 | 6 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 38965 | |
| 1 | 896 | 2.2% |
| 2 | 44 | 0.1% |
| 3 | 14 | < 0.1% |
| 4 | 6 | < 0.1% |
| 5 | 3 | < 0.1% |
| 14 | 14 | < 0.1% |
| 19 | 19 | < 0.1% |
| 24 | 48 | 0.1% |
| 25 | 25 | 0.1% |
| Value | Count | Frequency (%) |
| 26 | 26 | 0.1% |
| 25 | 25 | 0.1% |
| 24 | 48 | 0.1% |
| 19 | 19 | < 0.1% |
| 14 | 14 | < 0.1% |
| 5 | 3 | < 0.1% |
| 4 | 6 | < 0.1% |
| 3 | 14 | < 0.1% |
| 2 | 44 | 0.1% |
| 1 | 896 |
PreviousBookingsNotCanceled
Real number (ℝ)
| Distinct | 31 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.14645532 |
| Minimum | 0 |
|---|---|
| Maximum | 30 |
| Zeros | 38028 |
| Zeros (%) | 94.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 313.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 30 |
| Range | 30 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1.0019545 |
|---|---|
| Coefficient of variation (CV) | 6.8413668 |
| Kurtosis | 244.37828 |
| Mean | 0.14645532 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 13.241518 |
| Sum | 5867 |
| Variance | 1.0039129 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 38028 | |
| 1 | 973 | 2.4% |
| 2 | 388 | 1.0% |
| 3 | 204 | 0.5% |
| 4 | 127 | 0.3% |
| 5 | 91 | 0.2% |
| 6 | 56 | 0.1% |
| 7 | 37 | 0.1% |
| 8 | 33 | 0.1% |
| 9 | 24 | 0.1% |
| Other values (21) | 99 | 0.2% |
| Value | Count | Frequency (%) |
| 0 | 38028 | |
| 1 | 973 | 2.4% |
| 2 | 388 | 1.0% |
| 3 | 204 | 0.5% |
| 4 | 127 | 0.3% |
| 5 | 91 | 0.2% |
| 6 | 56 | 0.1% |
| 7 | 37 | 0.1% |
| 8 | 33 | 0.1% |
| 9 | 24 | 0.1% |
| Value | Count | Frequency (%) |
| 30 | 1 | < 0.1% |
| 29 | 1 | < 0.1% |
| 28 | 1 | < 0.1% |
| 27 | 2 | |
| 26 | 1 | < 0.1% |
| 25 | 3 | |
| 24 | 2 | |
| 23 | 2 | |
| 22 | 2 | |
| 21 | 2 |
ReservedRoomType
Categorical
| Distinct | 10 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 313.1 KiB |
| A | |
|---|---|
| D | |
| E | |
| G | 1610 |
| F | 1106 |
| Other values (5) | 1530 |
Length
| Max length | 16 |
|---|---|
| Median length | 16 |
| Mean length | 16 |
| Min length | 16 |
Characters and Unicode
| Total characters | 640960 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | C |
|---|---|
| 2nd row | C |
| 3rd row | A |
| 4th row | A |
| 5th row | A |
Common Values
| Value | Count | Frequency (%) |
| A | 23399 | |
| D | 7433 | 18.6% |
| E | 4982 | 12.4% |
| G | 1610 | 4.0% |
| F | 1106 | 2.8% |
| C | 918 | 2.3% |
| H | 601 | 1.5% |
| L | 6 | < 0.1% |
| B | 3 | < 0.1% |
| P | 2 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| a | 23399 | |
| d | 7433 | 18.6% |
| e | 4982 | 12.4% |
| g | 1610 | 4.0% |
| f | 1106 | 2.8% |
| c | 918 | 2.3% |
| h | 601 | 1.5% |
| l | 6 | < 0.1% |
| b | 3 | < 0.1% |
| p | 2 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 600900 | ||
| A | 23399 | 3.7% |
| D | 7433 | 1.2% |
| E | 4982 | 0.8% |
| G | 1610 | 0.3% |
| F | 1106 | 0.2% |
| C | 918 | 0.1% |
| H | 601 | 0.1% |
| L | 6 | < 0.1% |
| B | 3 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Space Separator | 600900 | |
| Uppercase Letter | 40060 | 6.2% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 23399 | |
| D | 7433 | 18.6% |
| E | 4982 | 12.4% |
| G | 1610 | 4.0% |
| F | 1106 | 2.8% |
| C | 918 | 2.3% |
| H | 601 | 1.5% |
| L | 6 | < 0.1% |
| B | 3 | < 0.1% |
| P | 2 | < 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 600900 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 600900 | |
| Latin | 40060 | 6.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 23399 | |
| D | 7433 | 18.6% |
| E | 4982 | 12.4% |
| G | 1610 | 4.0% |
| F | 1106 | 2.8% |
| C | 918 | 2.3% |
| H | 601 | 1.5% |
| L | 6 | < 0.1% |
| B | 3 | < 0.1% |
| P | 2 | < 0.1% |
Common
| Value | Count | Frequency (%) |
| 600900 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 640960 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 600900 | ||
| A | 23399 | 3.7% |
| D | 7433 | 1.2% |
| E | 4982 | 0.8% |
| G | 1610 | 0.3% |
| F | 1106 | 0.2% |
| C | 918 | 0.1% |
| H | 601 | 0.1% |
| L | 6 | < 0.1% |
| B | 3 | < 0.1% |
AssignedRoomType
Categorical
| Distinct | 11 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 313.1 KiB |
| A | |
|---|---|
| D | |
| E | |
| C | |
| G | |
| Other values (6) |
Length
| Max length | 16 |
|---|---|
| Median length | 16 |
| Mean length | 16 |
| Min length | 16 |
Characters and Unicode
| Total characters | 640960 |
|---|---|
| Distinct characters | 12 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | C |
|---|---|
| 2nd row | C |
| 3rd row | C |
| 4th row | A |
| 5th row | A |
Common Values
| Value | Count | Frequency (%) |
| A | 17046 | |
| D | 10339 | |
| E | 5638 | 14.1% |
| C | 2214 | 5.5% |
| G | 1853 | 4.6% |
| F | 1733 | 4.3% |
| H | 712 | 1.8% |
| I | 363 | 0.9% |
| B | 159 | 0.4% |
| P | 2 | < 0.1% |
Length
| Value | Count | Frequency (%) |
| a | 17046 | |
| d | 10339 | |
| e | 5638 | 14.1% |
| c | 2214 | 5.5% |
| g | 1853 | 4.6% |
| f | 1733 | 4.3% |
| h | 712 | 1.8% |
| i | 363 | 0.9% |
| b | 159 | 0.4% |
| p | 2 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 600900 | ||
| A | 17046 | 2.7% |
| D | 10339 | 1.6% |
| E | 5638 | 0.9% |
| C | 2214 | 0.3% |
| G | 1853 | 0.3% |
| F | 1733 | 0.3% |
| H | 712 | 0.1% |
| I | 363 | 0.1% |
| B | 159 | < 0.1% |
| Other values (2) | 3 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Space Separator | 600900 | |
| Uppercase Letter | 40060 | 6.2% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 17046 | |
| D | 10339 | |
| E | 5638 | 14.1% |
| C | 2214 | 5.5% |
| G | 1853 | 4.6% |
| F | 1733 | 4.3% |
| H | 712 | 1.8% |
| I | 363 | 0.9% |
| B | 159 | 0.4% |
| P | 2 | < 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 600900 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 600900 | |
| Latin | 40060 | 6.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 17046 | |
| D | 10339 | |
| E | 5638 | 14.1% |
| C | 2214 | 5.5% |
| G | 1853 | 4.6% |
| F | 1733 | 4.3% |
| H | 712 | 1.8% |
| I | 363 | 0.9% |
| B | 159 | 0.4% |
| P | 2 | < 0.1% |
Common
| Value | Count | Frequency (%) |
| 600900 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 640960 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 600900 | ||
| A | 17046 | 2.7% |
| D | 10339 | 1.6% |
| E | 5638 | 0.9% |
| C | 2214 | 0.3% |
| G | 1853 | 0.3% |
| F | 1733 | 0.3% |
| H | 712 | 0.1% |
| I | 363 | 0.1% |
| B | 159 | < 0.1% |
| Other values (2) | 3 | < 0.1% |
BookingChanges
Real number (ℝ)
| Distinct | 15 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.28796805 |
| Minimum | 0 |
|---|---|
| Maximum | 17 |
| Zeros | 32252 |
| Zeros (%) | 80.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 313.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 2 |
| Maximum | 17 |
| Range | 17 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.72654759 |
|---|---|
| Coefficient of variation (CV) | 2.5230146 |
| Kurtosis | 37.894806 |
| Mean | 0.28796805 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 4.4244027 |
| Sum | 11536 |
| Variance | 0.5278714 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 32252 | |
| 1 | 5469 | 13.7% |
| 2 | 1561 | 3.9% |
| 3 | 460 | 1.1% |
| 4 | 182 | 0.5% |
| 5 | 72 | 0.2% |
| 6 | 32 | 0.1% |
| 7 | 12 | < 0.1% |
| 8 | 8 | < 0.1% |
| 9 | 4 | < 0.1% |
| Other values (5) | 8 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 32252 | |
| 1 | 5469 | 13.7% |
| 2 | 1561 | 3.9% |
| 3 | 460 | 1.1% |
| 4 | 182 | 0.5% |
| 5 | 72 | 0.2% |
| 6 | 32 | 0.1% |
| 7 | 12 | < 0.1% |
| 8 | 8 | < 0.1% |
| 9 | 4 | < 0.1% |
| Value | Count | Frequency (%) |
| 17 | 1 | < 0.1% |
| 16 | 1 | < 0.1% |
| 13 | 2 | < 0.1% |
| 12 | 1 | < 0.1% |
| 10 | 3 | < 0.1% |
| 9 | 4 | < 0.1% |
| 8 | 8 | < 0.1% |
| 7 | 12 | < 0.1% |
| 6 | 32 | |
| 5 | 72 |
DepositType
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 313.1 KiB |
| No Deposit | |
|---|---|
| Non Refund | 1719 |
| Refundable | 142 |
Length
| Max length | 15 |
|---|---|
| Median length | 15 |
| Mean length | 15 |
| Min length | 15 |
Characters and Unicode
| Total characters | 600900 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | No Deposit |
|---|---|
| 2nd row | No Deposit |
| 3rd row | No Deposit |
| 4th row | No Deposit |
| 5th row | No Deposit |
Common Values
| Value | Count | Frequency (%) |
| No Deposit | 38199 | |
| Non Refund | 1719 | 4.3% |
| Refundable | 142 | 0.4% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| no | 38199 | |
| deposit | 38199 | |
| non | 1719 | 2.1% |
| refund | 1719 | 2.1% |
| refundable | 142 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| 240218 | ||
| o | 78117 | 13.0% |
| e | 40202 | 6.7% |
| N | 39918 | 6.6% |
| s | 38199 | 6.4% |
| i | 38199 | 6.4% |
| t | 38199 | 6.4% |
| p | 38199 | 6.4% |
| D | 38199 | 6.4% |
| n | 3580 | 0.6% |
| Other values (7) | 7870 | 1.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 280704 | |
| Space Separator | 240218 | |
| Uppercase Letter | 79978 | 13.3% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 78117 | |
| e | 40202 | |
| s | 38199 | |
| i | 38199 | |
| t | 38199 | |
| p | 38199 | |
| n | 3580 | 1.3% |
| f | 1861 | 0.7% |
| u | 1861 | 0.7% |
| d | 1861 | 0.7% |
| Other values (3) | 426 | 0.2% |
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 39918 | |
| D | 38199 | |
| R | 1861 | 2.3% |
Space Separator
| Value | Count | Frequency (%) |
| 240218 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 360682 | |
| Common | 240218 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| o | 78117 | |
| e | 40202 | |
| N | 39918 | |
| s | 38199 | |
| i | 38199 | |
| t | 38199 | |
| p | 38199 | |
| D | 38199 | |
| n | 3580 | 1.0% |
| R | 1861 | 0.5% |
| Other values (6) | 6009 | 1.7% |
Common
| Value | Count | Frequency (%) |
| 240218 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 600900 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 240218 | ||
| o | 78117 | 13.0% |
| e | 40202 | 6.7% |
| N | 39918 | 6.6% |
| s | 38199 | 6.4% |
| i | 38199 | 6.4% |
| t | 38199 | 6.4% |
| p | 38199 | 6.4% |
| D | 38199 | 6.4% |
| n | 3580 | 0.6% |
| Other values (7) | 7870 | 1.3% |
Agent
Categorical
| Distinct | 186 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 313.1 KiB |
| 240 | |
|---|---|
| NULL | |
| 250 | |
| 241 | |
| 40 | 1002 |
| Other values (181) |
Length
| Max length | 11 |
|---|---|
| Median length | 11 |
| Mean length | 11 |
| Min length | 11 |
Characters and Unicode
| Total characters | 440660 |
|---|---|
| Distinct characters | 14 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 36 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | NULL |
|---|---|
| 2nd row | NULL |
| 3rd row | NULL |
| 4th row | 304 |
| 5th row | 240 |
Common Values
| Value | Count | Frequency (%) |
| 240 | 13905 | |
| NULL | 8209 | |
| 250 | 2869 | 7.2% |
| 241 | 1721 | 4.3% |
| 40 | 1002 | 2.5% |
| 314 | 927 | 2.3% |
| 242 | 779 | 1.9% |
| 6 | 607 | 1.5% |
| 96 | 537 | 1.3% |
| 243 | 514 | 1.3% |
| Other values (176) | 8990 |
Length
| Value | Count | Frequency (%) |
| 240 | 13905 | |
| null | 8209 | |
| 250 | 2869 | 7.2% |
| 241 | 1721 | 4.3% |
| 40 | 1002 | 2.5% |
| 314 | 927 | 2.3% |
| 242 | 779 | 1.9% |
| 6 | 607 | 1.5% |
| 96 | 537 | 1.3% |
| 243 | 514 | 1.3% |
| Other values (176) | 8990 |
Most occurring characters
| Value | Count | Frequency (%) |
| 318055 | ||
| 2 | 23086 | 5.2% |
| 4 | 21011 | 4.8% |
| 0 | 18600 | 4.2% |
| L | 16418 | 3.7% |
| N | 8209 | 1.9% |
| U | 8209 | 1.9% |
| 1 | 7873 | 1.8% |
| 5 | 5514 | 1.3% |
| 3 | 4338 | 1.0% |
| Other values (4) | 9347 | 2.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Space Separator | 318055 | |
| Decimal Number | 89769 | 20.4% |
| Uppercase Letter | 32836 | 7.5% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 23086 | |
| 4 | 21011 | |
| 0 | 18600 | |
| 1 | 7873 | 8.8% |
| 5 | 5514 | 6.1% |
| 3 | 4338 | 4.8% |
| 6 | 2926 | 3.3% |
| 7 | 2303 | 2.6% |
| 8 | 2206 | 2.5% |
| 9 | 1912 | 2.1% |
Uppercase Letter
| Value | Count | Frequency (%) |
| L | 16418 | |
| N | 8209 | |
| U | 8209 |
Space Separator
| Value | Count | Frequency (%) |
| 318055 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 407824 | |
| Latin | 32836 | 7.5% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 318055 | ||
| 2 | 23086 | 5.7% |
| 4 | 21011 | 5.2% |
| 0 | 18600 | 4.6% |
| 1 | 7873 | 1.9% |
| 5 | 5514 | 1.4% |
| 3 | 4338 | 1.1% |
| 6 | 2926 | 0.7% |
| 7 | 2303 | 0.6% |
| 8 | 2206 | 0.5% |
Latin
| Value | Count | Frequency (%) |
| L | 16418 | |
| N | 8209 | |
| U | 8209 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 440660 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 318055 | ||
| 2 | 23086 | 5.2% |
| 4 | 21011 | 4.8% |
| 0 | 18600 | 4.2% |
| L | 16418 | 3.7% |
| N | 8209 | 1.9% |
| U | 8209 | 1.9% |
| 1 | 7873 | 1.8% |
| 5 | 5514 | 1.3% |
| 3 | 4338 | 1.0% |
| Other values (4) | 9347 | 2.1% |
Company
Categorical
HIGH CARDINALITY  IMBALANCE 
| Distinct | 236 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 313.1 KiB |
| NULL | |
|---|---|
| 223 | 784 |
| 281 | 138 |
| 154 | 133 |
| 405 | 100 |
| Other values (231) | 1953 |
Length
| Max length | 11 |
|---|---|
| Median length | 11 |
| Mean length | 11 |
| Min length | 11 |
Characters and Unicode
| Total characters | 440660 |
|---|---|
| Distinct characters | 14 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 68 ? |
|---|---|
| Unique (%) | 0.2% |
Sample
| 1st row | NULL |
|---|---|
| 2nd row | NULL |
| 3rd row | NULL |
| 4th row | NULL |
| 5th row | NULL |
Common Values
| Value | Count | Frequency (%) |
| NULL | 36952 | |
| 223 | 784 | 2.0% |
| 281 | 138 | 0.3% |
| 154 | 133 | 0.3% |
| 405 | 100 | 0.2% |
| 94 | 87 | 0.2% |
| 135 | 64 | 0.2% |
| 331 | 58 | 0.1% |
| 498 | 58 | 0.1% |
| 47 | 56 | 0.1% |
| Other values (226) | 1630 | 4.1% |
Length
| Value | Count | Frequency (%) |
| null | 36952 | |
| 223 | 784 | 2.0% |
| 281 | 138 | 0.3% |
| 154 | 133 | 0.3% |
| 405 | 100 | 0.2% |
| 94 | 87 | 0.2% |
| 135 | 64 | 0.2% |
| 331 | 58 | 0.1% |
| 498 | 58 | 0.1% |
| 47 | 56 | 0.1% |
| Other values (226) | 1630 | 4.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 284028 | ||
| L | 73904 | 16.8% |
| N | 36952 | 8.4% |
| U | 36952 | 8.4% |
| 2 | 2353 | 0.5% |
| 3 | 1673 | 0.4% |
| 1 | 1019 | 0.2% |
| 4 | 897 | 0.2% |
| 5 | 626 | 0.1% |
| 8 | 536 | 0.1% |
| Other values (4) | 1720 | 0.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Space Separator | 284028 | |
| Uppercase Letter | 147808 | |
| Decimal Number | 8824 | 2.0% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 2353 | |
| 3 | 1673 | |
| 1 | 1019 | |
| 4 | 897 | 10.2% |
| 5 | 626 | 7.1% |
| 8 | 536 | 6.1% |
| 0 | 536 | 6.1% |
| 9 | 494 | 5.6% |
| 7 | 428 | 4.9% |
| 6 | 262 | 3.0% |
Uppercase Letter
| Value | Count | Frequency (%) |
| L | 73904 | |
| N | 36952 | |
| U | 36952 |
Space Separator
| Value | Count | Frequency (%) |
| 284028 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 292852 | |
| Latin | 147808 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 284028 | ||
| 2 | 2353 | 0.8% |
| 3 | 1673 | 0.6% |
| 1 | 1019 | 0.3% |
| 4 | 897 | 0.3% |
| 5 | 626 | 0.2% |
| 8 | 536 | 0.2% |
| 0 | 536 | 0.2% |
| 9 | 494 | 0.2% |
| 7 | 428 | 0.1% |
Latin
| Value | Count | Frequency (%) |
| L | 73904 | |
| N | 36952 | |
| U | 36952 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 440660 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 284028 | ||
| L | 73904 | 16.8% |
| N | 36952 | 8.4% |
| U | 36952 | 8.4% |
| 2 | 2353 | 0.5% |
| 3 | 1673 | 0.4% |
| 1 | 1019 | 0.2% |
| 4 | 897 | 0.2% |
| 5 | 626 | 0.1% |
| 8 | 536 | 0.1% |
| Other values (4) | 1720 | 0.4% |
DaysInWaitingList
Real number (ℝ)
| Distinct | 44 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.52775836 |
| Minimum | 0 |
|---|---|
| Maximum | 185 |
| Zeros | 39805 |
| Zeros (%) | 99.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 313.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 185 |
| Range | 185 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 7.4285804 |
|---|---|
| Coefficient of variation (CV) | 14.075723 |
| Kurtosis | 251.48458 |
| Mean | 0.52775836 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 15.436884 |
| Sum | 21142 |
| Variance | 55.183807 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 39805 | |
| 122 | 55 | 0.1% |
| 65 | 27 | 0.1% |
| 47 | 23 | 0.1% |
| 75 | 20 | < 0.1% |
| 101 | 18 | < 0.1% |
| 125 | 16 | < 0.1% |
| 150 | 11 | < 0.1% |
| 14 | 6 | < 0.1% |
| 60 | 5 | < 0.1% |
| Other values (34) | 74 | 0.2% |
| Value | Count | Frequency (%) |
| 0 | 39805 | |
| 1 | 5 | < 0.1% |
| 2 | 2 | < 0.1% |
| 4 | 3 | < 0.1% |
| 5 | 3 | < 0.1% |
| 6 | 4 | < 0.1% |
| 8 | 3 | < 0.1% |
| 11 | 1 | < 0.1% |
| 13 | 2 | < 0.1% |
| 14 | 6 | < 0.1% |
| Value | Count | Frequency (%) |
| 185 | 2 | < 0.1% |
| 154 | 2 | < 0.1% |
| 150 | 11 | < 0.1% |
| 142 | 1 | < 0.1% |
| 125 | 16 | < 0.1% |
| 122 | 55 | |
| 121 | 2 | < 0.1% |
| 116 | 1 | < 0.1% |
| 113 | 5 | < 0.1% |
| 109 | 1 | < 0.1% |
CustomerType
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 313.1 KiB |
| Transient | |
|---|---|
| Transient-Party | |
| Contract | 1776 |
| Group | 284 |
Length
| Max length | 15 |
|---|---|
| Median length | 9 |
| Mean length | 10.094209 |
| Min length | 5 |
Characters and Unicode
| Total characters | 404374 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Transient |
|---|---|
| 2nd row | Transient |
| 3rd row | Transient |
| 4th row | Transient |
| 5th row | Transient |
Common Values
| Value | Count | Frequency (%) |
| Transient | 30209 | |
| Transient-Party | 7791 | 19.4% |
| Contract | 1776 | 4.4% |
| Group | 284 | 0.7% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| transient | 30209 | |
| transient-party | 7791 | 19.4% |
| contract | 1776 | 4.4% |
| group | 284 | 0.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 77776 | |
| t | 49343 | |
| r | 47851 | |
| a | 47567 | |
| T | 38000 | |
| s | 38000 | |
| i | 38000 | |
| e | 38000 | |
| y | 7791 | 1.9% |
| - | 7791 | 1.9% |
| Other values (7) | 14255 | 3.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 348732 | |
| Uppercase Letter | 47851 | 11.8% |
| Dash Punctuation | 7791 | 1.9% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| n | 77776 | |
| t | 49343 | |
| r | 47851 | |
| a | 47567 | |
| s | 38000 | |
| i | 38000 | |
| e | 38000 | |
| y | 7791 | 2.2% |
| o | 2060 | 0.6% |
| c | 1776 | 0.5% |
| Other values (2) | 568 | 0.2% |
Uppercase Letter
| Value | Count | Frequency (%) |
| T | 38000 | |
| P | 7791 | 16.3% |
| C | 1776 | 3.7% |
| G | 284 | 0.6% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 7791 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 396583 | |
| Common | 7791 | 1.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| n | 77776 | |
| t | 49343 | |
| r | 47851 | |
| a | 47567 | |
| T | 38000 | |
| s | 38000 | |
| i | 38000 | |
| e | 38000 | |
| y | 7791 | 2.0% |
| P | 7791 | 2.0% |
| Other values (6) | 6464 | 1.6% |
Common
| Value | Count | Frequency (%) |
| - | 7791 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 404374 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| n | 77776 | |
| t | 49343 | |
| r | 47851 | |
| a | 47567 | |
| T | 38000 | |
| s | 38000 | |
| i | 38000 | |
| e | 38000 | |
| y | 7791 | 1.9% |
| - | 7791 | 1.9% |
| Other values (7) | 14255 | 3.5% |
ADR
Real number (ℝ)
| Distinct | 5880 |
|---|---|
| Distinct (%) | 14.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 94.95293 |
| Minimum | -6.38 |
|---|---|
| Maximum | 508 |
| Zeros | 751 |
| Zeros (%) | 1.9% |
| Negative | 1 |
| Negative (%) | < 0.1% |
| Memory size | 313.1 KiB |
Quantile statistics
| Minimum | -6.38 |
|---|---|
| 5-th percentile | 30 |
| Q1 | 50 |
| median | 75 |
| Q3 | 125 |
| 95-th percentile | 221.0035 |
| Maximum | 508 |
| Range | 514.38 |
| Interquartile range (IQR) | 75 |
Descriptive statistics
| Standard deviation | 61.442418 |
|---|---|
| Coefficient of variation (CV) | 0.64708291 |
| Kurtosis | 1.3400805 |
| Mean | 94.95293 |
| Median Absolute Deviation (MAD) | 30 |
| Skewness | 1.2373892 |
| Sum | 3803814.4 |
| Variance | 3775.1707 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 48 | 1024 | 2.6% |
| 0 | 751 | 1.9% |
| 68 | 489 | 1.2% |
| 60 | 475 | 1.2% |
| 80 | 463 | 1.2% |
| 85 | 446 | 1.1% |
| 35 | 417 | 1.0% |
| 55 | 414 | 1.0% |
| 40 | 396 | 1.0% |
| 66 | 390 | 1.0% |
| Other values (5870) | 34795 |
| Value | Count | Frequency (%) |
| -6.38 | 1 | < 0.1% |
| 0 | 751 | |
| 0.26 | 1 | < 0.1% |
| 1.56 | 2 | < 0.1% |
| 1.8 | 1 | < 0.1% |
| 2 | 5 | < 0.1% |
| 2.4 | 1 | < 0.1% |
| 3 | 1 | < 0.1% |
| 4 | 21 | 0.1% |
| 4.5 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 508 | 1 | |
| 450 | 1 | |
| 437 | 1 | |
| 426.25 | 1 | |
| 402 | 1 | |
| 397.38 | 1 | |
| 392 | 2 | |
| 388 | 2 | |
| 387 | 1 | |
| 384 | 1 |
RequiredCarParkingSpaces
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 313.1 KiB |
| 0 | |
|---|---|
| 1 | |
| 2 | 25 |
| 8 | 2 |
| 3 | 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 40060 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 34570 | |
| 1 | 5462 | 13.6% |
| 2 | 25 | 0.1% |
| 8 | 2 | < 0.1% |
| 3 | 1 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 34570 | |
| 1 | 5462 | 13.6% |
| 2 | 25 | 0.1% |
| 8 | 2 | < 0.1% |
| 3 | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 34570 | |
| 1 | 5462 | 13.6% |
| 2 | 25 | 0.1% |
| 8 | 2 | < 0.1% |
| 3 | 1 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 40060 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 34570 | |
| 1 | 5462 | 13.6% |
| 2 | 25 | 0.1% |
| 8 | 2 | < 0.1% |
| 3 | 1 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 40060 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 34570 | |
| 1 | 5462 | 13.6% |
| 2 | 25 | 0.1% |
| 8 | 2 | < 0.1% |
| 3 | 1 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 40060 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 34570 | |
| 1 | 5462 | 13.6% |
| 2 | 25 | 0.1% |
| 8 | 2 | < 0.1% |
| 3 | 1 | < 0.1% |
TotalOfSpecialRequests
Real number (ℝ)
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.61977034 |
| Minimum | 0 |
|---|---|
| Maximum | 5 |
| Zeros | 22361 |
| Zeros (%) | 55.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 313.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1 |
| 95-th percentile | 2 |
| Maximum | 5 |
| Range | 5 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.8139296 |
|---|---|
| Coefficient of variation (CV) | 1.3132761 |
| Kurtosis | 1.2074689 |
| Mean | 0.61977034 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.2477349 |
| Sum | 24828 |
| Variance | 0.66248139 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 22361 | |
| 1 | 11806 | |
| 2 | 4827 | 12.0% |
| 3 | 910 | 2.3% |
| 4 | 142 | 0.4% |
| 5 | 14 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 22361 | |
| 1 | 11806 | |
| 2 | 4827 | 12.0% |
| 3 | 910 | 2.3% |
| 4 | 142 | 0.4% |
| 5 | 14 | < 0.1% |
| Value | Count | Frequency (%) |
| 5 | 14 | < 0.1% |
| 4 | 142 | 0.4% |
| 3 | 910 | 2.3% |
| 2 | 4827 | 12.0% |
| 1 | 11806 | |
| 0 | 22361 |
ReservationStatus
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 313.1 KiB |
| Check-Out | |
|---|---|
| Canceled | |
| No-Show | 291 |
Length
| Max length | 9 |
|---|---|
| Median length | 9 |
| Mean length | 8.7151023 |
| Min length | 7 |
Characters and Unicode
| Total characters | 349127 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Check-Out |
|---|---|
| 2nd row | Check-Out |
| 3rd row | Check-Out |
| 4th row | Check-Out |
| 5th row | Check-Out |
Common Values
| Value | Count | Frequency (%) |
| Check-Out | 28938 | |
| Canceled | 10831 | 27.0% |
| No-Show | 291 | 0.7% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| check-out | 28938 | |
| canceled | 10831 | 27.0% |
| no-show | 291 | 0.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 50600 | |
| C | 39769 | |
| c | 39769 | |
| h | 29229 | |
| - | 29229 | |
| u | 28938 | |
| t | 28938 | |
| O | 28938 | |
| k | 28938 | |
| a | 10831 | 3.1% |
| Other values (7) | 33948 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 250609 | |
| Uppercase Letter | 69289 | 19.8% |
| Dash Punctuation | 29229 | 8.4% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 50600 | |
| c | 39769 | |
| h | 29229 | |
| u | 28938 | |
| t | 28938 | |
| k | 28938 | |
| a | 10831 | 4.3% |
| n | 10831 | 4.3% |
| l | 10831 | 4.3% |
| d | 10831 | 4.3% |
| Other values (2) | 873 | 0.3% |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 39769 | |
| O | 28938 | |
| N | 291 | 0.4% |
| S | 291 | 0.4% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 29229 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 319898 | |
| Common | 29229 | 8.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 50600 | |
| C | 39769 | |
| c | 39769 | |
| h | 29229 | |
| u | 28938 | |
| t | 28938 | |
| O | 28938 | |
| k | 28938 | |
| a | 10831 | 3.4% |
| n | 10831 | 3.4% |
| Other values (6) | 23117 |
Common
| Value | Count | Frequency (%) |
| - | 29229 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 349127 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 50600 | |
| C | 39769 | |
| c | 39769 | |
| h | 29229 | |
| - | 29229 | |
| u | 28938 | |
| t | 28938 | |
| O | 28938 | |
| k | 28938 | |
| a | 10831 | 3.1% |
| Other values (7) | 33948 |
ReservationStatusDate
Categorical
| Distinct | 913 |
|---|---|
| Distinct (%) | 2.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 313.1 KiB |
| 2017-01-19 | 147 |
|---|---|
| 2016-02-09 | 145 |
| 2016-02-29 | 129 |
| 2017-02-28 | 124 |
| 2015-11-15 | 124 |
| Other values (908) |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 400600 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 31 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | 2015-07-01 |
|---|---|
| 2nd row | 2015-07-01 |
| 3rd row | 2015-07-02 |
| 4th row | 2015-07-02 |
| 5th row | 2015-07-03 |
Common Values
| Value | Count | Frequency (%) |
| 2017-01-19 | 147 | 0.4% |
| 2016-02-09 | 145 | 0.4% |
| 2016-02-29 | 129 | 0.3% |
| 2017-02-28 | 124 | 0.3% |
| 2015-11-15 | 124 | 0.3% |
| 2016-10-06 | 121 | 0.3% |
| 2015-12-08 | 115 | 0.3% |
| 2017-03-06 | 114 | 0.3% |
| 2017-05-25 | 114 | 0.3% |
| 2016-04-04 | 110 | 0.3% |
| Other values (903) | 38817 |
Length
| Value | Count | Frequency (%) |
| 2017-01-19 | 147 | 0.4% |
| 2016-02-09 | 145 | 0.4% |
| 2016-02-29 | 129 | 0.3% |
| 2017-02-28 | 124 | 0.3% |
| 2015-11-15 | 124 | 0.3% |
| 2016-10-06 | 121 | 0.3% |
| 2015-12-08 | 115 | 0.3% |
| 2017-03-06 | 114 | 0.3% |
| 2017-05-25 | 114 | 0.3% |
| 2016-04-04 | 110 | 0.3% |
| Other values (903) | 38817 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 90317 | |
| - | 80120 | |
| 1 | 73097 | |
| 2 | 62895 | |
| 6 | 26071 | 6.5% |
| 7 | 20218 | 5.0% |
| 5 | 16092 | 4.0% |
| 3 | 9521 | 2.4% |
| 8 | 7966 | 2.0% |
| 4 | 7211 | 1.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 320480 | |
| Dash Punctuation | 80120 | 20.0% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 90317 | |
| 1 | 73097 | |
| 2 | 62895 | |
| 6 | 26071 | 8.1% |
| 7 | 20218 | 6.3% |
| 5 | 16092 | 5.0% |
| 3 | 9521 | 3.0% |
| 8 | 7966 | 2.5% |
| 4 | 7211 | 2.3% |
| 9 | 7092 | 2.2% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 80120 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 400600 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 90317 | |
| - | 80120 | |
| 1 | 73097 | |
| 2 | 62895 | |
| 6 | 26071 | 6.5% |
| 7 | 20218 | 5.0% |
| 5 | 16092 | 4.0% |
| 3 | 9521 | 2.4% |
| 8 | 7966 | 2.0% |
| 4 | 7211 | 1.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 400600 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 90317 | |
| - | 80120 | |
| 1 | 73097 | |
| 2 | 62895 | |
| 6 | 26071 | 6.5% |
| 7 | 20218 | 5.0% |
| 5 | 16092 | 4.0% |
| 3 | 9521 | 2.4% |
| 8 | 7966 | 2.0% |
| 4 | 7211 | 1.8% |
| LeadTime | ArrivalDateWeekNumber | ArrivalDateDayOfMonth | StaysInWeekendNights | StaysInWeekNights | Adults | PreviousCancellations | PreviousBookingsNotCanceled | BookingChanges | DaysInWaitingList | ADR | TotalOfSpecialRequests | IsCanceled | ArrivalDateYear | ArrivalDateMonth | Children | Babies | Meal | MarketSegment | DistributionChannel | IsRepeatedGuest | ReservedRoomType | AssignedRoomType | DepositType | CustomerType | RequiredCarParkingSpaces | ReservationStatus | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| LeadTime | 1.000 | 0.128 | -0.012 | 0.421 | 0.526 | 0.235 | 0.114 | -0.215 | 0.076 | 0.075 | 0.157 | 0.023 | 0.235 | 0.104 | 0.170 | 0.020 | 0.000 | 0.117 | 0.198 | 0.138 | 0.141 | 0.046 | 0.051 | 0.178 | 0.147 | 0.076 | 0.172 |
| ArrivalDateWeekNumber | 0.128 | 1.000 | 0.072 | 0.065 | 0.071 | 0.068 | 0.066 | -0.073 | 0.014 | 0.049 | 0.139 | 0.041 | 0.108 | 0.421 | 0.799 | 0.084 | 0.033 | 0.099 | 0.154 | 0.129 | 0.125 | 0.065 | 0.051 | 0.130 | 0.146 | 0.011 | 0.083 |
| ArrivalDateDayOfMonth | -0.012 | 0.072 | 1.000 | -0.028 | -0.031 | 0.009 | -0.030 | 0.005 | -0.002 | 0.030 | 0.039 | 0.012 | 0.034 | 0.037 | 0.062 | 0.013 | 0.005 | 0.050 | 0.044 | 0.053 | 0.015 | 0.014 | 0.013 | 0.096 | 0.046 | 0.010 | 0.026 |
| StaysInWeekendNights | 0.421 | 0.065 | -0.028 | 1.000 | 0.574 | 0.183 | -0.015 | -0.147 | 0.047 | -0.001 | 0.166 | 0.068 | 0.096 | 0.040 | 0.095 | 0.032 | 0.020 | 0.094 | 0.143 | 0.126 | 0.125 | 0.063 | 0.030 | 0.035 | 0.165 | 0.050 | 0.070 |
| StaysInWeekNights | 0.526 | 0.071 | -0.031 | 0.574 | 1.000 | 0.199 | -0.010 | -0.159 | 0.086 | 0.047 | 0.207 | 0.069 | 0.035 | 0.030 | 0.063 | 0.000 | 0.000 | 0.072 | 0.085 | 0.044 | 0.042 | 0.038 | 0.026 | 0.031 | 0.131 | 0.040 | 0.025 |
| Adults | 0.235 | 0.068 | 0.009 | 0.183 | 0.199 | 1.000 | -0.030 | -0.272 | -0.027 | -0.008 | 0.395 | 0.155 | 0.028 | 0.023 | 0.019 | 0.000 | 0.000 | 0.000 | 0.012 | 0.011 | 0.000 | 0.000 | 0.000 | 0.000 | 0.127 | 0.000 | 0.019 |
| PreviousCancellations | 0.114 | 0.066 | -0.030 | -0.015 | -0.010 | -0.030 | 1.000 | 0.113 | -0.047 | -0.012 | -0.077 | -0.064 | 0.095 | 0.079 | 0.068 | 0.000 | 0.000 | 0.089 | 0.055 | 0.044 | 0.066 | 0.020 | 0.031 | 0.157 | 0.007 | 0.007 | 0.068 |
| PreviousBookingsNotCanceled | -0.215 | -0.073 | 0.005 | -0.147 | -0.159 | -0.272 | 0.113 | 1.000 | 0.007 | -0.009 | -0.149 | -0.005 | 0.058 | 0.039 | 0.022 | 0.003 | 0.000 | 0.024 | 0.119 | 0.133 | 0.309 | 0.017 | 0.008 | 0.008 | 0.037 | 0.017 | 0.040 |
| BookingChanges | 0.076 | 0.014 | -0.002 | 0.047 | 0.086 | -0.027 | -0.047 | 0.007 | 1.000 | 0.021 | 0.024 | 0.013 | 0.073 | 0.030 | 0.017 | 0.031 | 0.048 | 0.083 | 0.045 | 0.057 | 0.000 | 0.013 | 0.048 | 0.039 | 0.068 | 0.026 | 0.053 |
| DaysInWaitingList | 0.075 | 0.049 | 0.030 | -0.001 | 0.047 | -0.008 | -0.012 | -0.009 | 0.021 | 1.000 | -0.006 | -0.058 | 0.035 | 0.059 | 0.062 | 0.000 | 0.000 | 0.103 | 0.072 | 0.048 | 0.000 | 0.015 | 0.017 | 0.164 | 0.083 | 0.040 | 0.022 |
| ADR | 0.157 | 0.139 | 0.039 | 0.166 | 0.207 | 0.395 | -0.077 | -0.149 | 0.024 | -0.006 | 1.000 | 0.194 | 0.114 | 0.145 | 0.287 | 0.188 | 0.042 | 0.136 | 0.216 | 0.165 | 0.164 | 0.168 | 0.135 | 0.102 | 0.130 | 0.052 | 0.085 |
| TotalOfSpecialRequests | 0.023 | 0.041 | 0.012 | 0.068 | 0.069 | 0.155 | -0.064 | -0.005 | 0.013 | -0.058 | 0.194 | 1.000 | 0.115 | 0.076 | 0.083 | 0.042 | 0.116 | 0.073 | 0.209 | 0.142 | 0.067 | 0.071 | 0.055 | 0.136 | 0.105 | 0.040 | 0.081 |
| IsCanceled | 0.235 | 0.108 | 0.034 | 0.096 | 0.035 | 0.028 | 0.095 | 0.058 | 0.073 | 0.035 | 0.114 | 0.115 | 1.000 | 0.047 | 0.115 | 0.087 | 0.023 | 0.110 | 0.253 | 0.136 | 0.103 | 0.081 | 0.183 | 0.323 | 0.141 | 0.247 | 1.000 |
| ArrivalDateYear | 0.104 | 0.421 | 0.037 | 0.040 | 0.030 | 0.023 | 0.079 | 0.039 | 0.030 | 0.059 | 0.145 | 0.076 | 0.047 | 1.000 | 0.428 | 0.047 | 0.010 | 0.070 | 0.096 | 0.037 | 0.075 | 0.069 | 0.038 | 0.063 | 0.053 | 0.015 | 0.034 |
| ArrivalDateMonth | 0.170 | 0.799 | 0.062 | 0.095 | 0.063 | 0.019 | 0.068 | 0.022 | 0.017 | 0.062 | 0.287 | 0.083 | 0.115 | 0.428 | 1.000 | 0.090 | 0.036 | 0.115 | 0.165 | 0.133 | 0.122 | 0.067 | 0.048 | 0.139 | 0.153 | 0.017 | 0.087 |
| Children | 0.020 | 0.084 | 0.013 | 0.032 | 0.000 | 0.000 | 0.000 | 0.003 | 0.031 | 0.000 | 0.188 | 0.042 | 0.087 | 0.047 | 0.090 | 1.000 | 0.048 | 0.031 | 0.101 | 0.055 | 0.046 | 0.420 | 0.357 | 0.045 | 0.066 | 0.029 | 0.074 |
| Babies | 0.000 | 0.033 | 0.005 | 0.020 | 0.000 | 0.000 | 0.000 | 0.000 | 0.048 | 0.000 | 0.042 | 0.116 | 0.023 | 0.010 | 0.036 | 0.048 | 1.000 | 0.020 | 0.044 | 0.029 | 0.020 | 0.059 | 0.065 | 0.017 | 0.018 | 0.025 | 0.015 |
| Meal | 0.117 | 0.099 | 0.050 | 0.094 | 0.072 | 0.000 | 0.089 | 0.024 | 0.083 | 0.103 | 0.136 | 0.073 | 0.110 | 0.070 | 0.115 | 0.031 | 0.020 | 1.000 | 0.207 | 0.076 | 0.074 | 0.100 | 0.234 | 0.184 | 0.145 | 0.038 | 0.081 |
| MarketSegment | 0.198 | 0.154 | 0.044 | 0.143 | 0.085 | 0.012 | 0.055 | 0.119 | 0.045 | 0.072 | 0.216 | 0.209 | 0.253 | 0.096 | 0.165 | 0.101 | 0.044 | 0.207 | 1.000 | 0.686 | 0.273 | 0.179 | 0.150 | 0.326 | 0.406 | 0.099 | 0.183 |
| DistributionChannel | 0.138 | 0.129 | 0.053 | 0.126 | 0.044 | 0.011 | 0.044 | 0.133 | 0.057 | 0.048 | 0.165 | 0.142 | 0.136 | 0.037 | 0.133 | 0.055 | 0.029 | 0.076 | 0.686 | 1.000 | 0.210 | 0.152 | 0.106 | 0.063 | 0.116 | 0.076 | 0.099 |
| IsRepeatedGuest | 0.141 | 0.125 | 0.015 | 0.125 | 0.042 | 0.000 | 0.066 | 0.309 | 0.000 | 0.000 | 0.164 | 0.067 | 0.103 | 0.075 | 0.122 | 0.046 | 0.020 | 0.074 | 0.273 | 0.210 | 1.000 | 0.075 | 0.073 | 0.044 | 0.155 | 0.060 | 0.104 |
| ReservedRoomType | 0.046 | 0.065 | 0.014 | 0.063 | 0.038 | 0.000 | 0.020 | 0.017 | 0.013 | 0.015 | 0.168 | 0.071 | 0.081 | 0.069 | 0.067 | 0.420 | 0.059 | 0.100 | 0.179 | 0.152 | 0.075 | 1.000 | 0.738 | 0.091 | 0.122 | 0.059 | 0.058 |
| AssignedRoomType | 0.051 | 0.051 | 0.013 | 0.030 | 0.026 | 0.000 | 0.031 | 0.008 | 0.048 | 0.017 | 0.135 | 0.055 | 0.183 | 0.038 | 0.048 | 0.357 | 0.065 | 0.234 | 0.150 | 0.106 | 0.073 | 0.738 | 1.000 | 0.127 | 0.101 | 0.073 | 0.131 |
| DepositType | 0.178 | 0.130 | 0.096 | 0.035 | 0.031 | 0.000 | 0.157 | 0.008 | 0.039 | 0.164 | 0.102 | 0.136 | 0.323 | 0.063 | 0.139 | 0.045 | 0.017 | 0.184 | 0.326 | 0.063 | 0.044 | 0.091 | 0.127 | 1.000 | 0.101 | 0.063 | 0.230 |
| CustomerType | 0.147 | 0.146 | 0.046 | 0.165 | 0.131 | 0.127 | 0.007 | 0.037 | 0.068 | 0.083 | 0.130 | 0.105 | 0.141 | 0.053 | 0.153 | 0.066 | 0.018 | 0.145 | 0.406 | 0.116 | 0.155 | 0.122 | 0.101 | 0.101 | 1.000 | 0.063 | 0.100 |
| RequiredCarParkingSpaces | 0.076 | 0.011 | 0.010 | 0.050 | 0.040 | 0.000 | 0.007 | 0.017 | 0.026 | 0.040 | 0.052 | 0.040 | 0.247 | 0.015 | 0.017 | 0.029 | 0.025 | 0.038 | 0.099 | 0.076 | 0.060 | 0.059 | 0.073 | 0.063 | 0.063 | 1.000 | 0.174 |
| ReservationStatus | 0.172 | 0.083 | 0.026 | 0.070 | 0.025 | 0.019 | 0.068 | 0.040 | 0.053 | 0.022 | 0.085 | 0.081 | 1.000 | 0.034 | 0.087 | 0.074 | 0.015 | 0.081 | 0.183 | 0.099 | 0.104 | 0.058 | 0.131 | 0.230 | 0.100 | 0.174 | 1.000 |
| IsCanceled | LeadTime | ArrivalDateYear | ArrivalDateMonth | ArrivalDateWeekNumber | ArrivalDateDayOfMonth | StaysInWeekendNights | StaysInWeekNights | Adults | Children | Babies | Meal | Country | MarketSegment | DistributionChannel | IsRepeatedGuest | PreviousCancellations | PreviousBookingsNotCanceled | ReservedRoomType | AssignedRoomType | BookingChanges | DepositType | Agent | Company | DaysInWaitingList | CustomerType | ADR | RequiredCarParkingSpaces | TotalOfSpecialRequests | ReservationStatus | ReservationStatusDate | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | 342 | 2015 | July | 27 | 1 | 0 | 0 | 2 | 0 | 0 | BB | PRT | Direct | Direct | 0 | 0 | 0 | C | C | 3 | No Deposit | NULL | NULL | 0 | Transient | 0.0 | 0 | 0 | Check-Out | 2015-07-01 |
| 1 | 0 | 737 | 2015 | July | 27 | 1 | 0 | 0 | 2 | 0 | 0 | BB | PRT | Direct | Direct | 0 | 0 | 0 | C | C | 4 | No Deposit | NULL | NULL | 0 | Transient | 0.0 | 0 | 0 | Check-Out | 2015-07-01 |
| 2 | 0 | 7 | 2015 | July | 27 | 1 | 0 | 1 | 1 | 0 | 0 | BB | GBR | Direct | Direct | 0 | 0 | 0 | A | C | 0 | No Deposit | NULL | NULL | 0 | Transient | 75.0 | 0 | 0 | Check-Out | 2015-07-02 |
| 3 | 0 | 13 | 2015 | July | 27 | 1 | 0 | 1 | 1 | 0 | 0 | BB | GBR | Corporate | Corporate | 0 | 0 | 0 | A | A | 0 | No Deposit | 304 | NULL | 0 | Transient | 75.0 | 0 | 0 | Check-Out | 2015-07-02 |
| 4 | 0 | 14 | 2015 | July | 27 | 1 | 0 | 2 | 2 | 0 | 0 | BB | GBR | Online TA | TA/TO | 0 | 0 | 0 | A | A | 0 | No Deposit | 240 | NULL | 0 | Transient | 98.0 | 0 | 1 | Check-Out | 2015-07-03 |
| 5 | 0 | 14 | 2015 | July | 27 | 1 | 0 | 2 | 2 | 0 | 0 | BB | GBR | Online TA | TA/TO | 0 | 0 | 0 | A | A | 0 | No Deposit | 240 | NULL | 0 | Transient | 98.0 | 0 | 1 | Check-Out | 2015-07-03 |
| 6 | 0 | 0 | 2015 | July | 27 | 1 | 0 | 2 | 2 | 0 | 0 | BB | PRT | Direct | Direct | 0 | 0 | 0 | C | C | 0 | No Deposit | NULL | NULL | 0 | Transient | 107.0 | 0 | 0 | Check-Out | 2015-07-03 |
| 7 | 0 | 9 | 2015 | July | 27 | 1 | 0 | 2 | 2 | 0 | 0 | FB | PRT | Direct | Direct | 0 | 0 | 0 | C | C | 0 | No Deposit | 303 | NULL | 0 | Transient | 103.0 | 0 | 1 | Check-Out | 2015-07-03 |
| 8 | 1 | 85 | 2015 | July | 27 | 1 | 0 | 3 | 2 | 0 | 0 | BB | PRT | Online TA | TA/TO | 0 | 0 | 0 | A | A | 0 | No Deposit | 240 | NULL | 0 | Transient | 82.0 | 0 | 1 | Canceled | 2015-05-06 |
| 9 | 1 | 75 | 2015 | July | 27 | 1 | 0 | 3 | 2 | 0 | 0 | HB | PRT | Offline TA/TO | TA/TO | 0 | 0 | 0 | D | D | 0 | No Deposit | 15 | NULL | 0 | Transient | 105.5 | 0 | 0 | Canceled | 2015-04-22 |
| IsCanceled | LeadTime | ArrivalDateYear | ArrivalDateMonth | ArrivalDateWeekNumber | ArrivalDateDayOfMonth | StaysInWeekendNights | StaysInWeekNights | Adults | Children | Babies | Meal | Country | MarketSegment | DistributionChannel | IsRepeatedGuest | PreviousCancellations | PreviousBookingsNotCanceled | ReservedRoomType | AssignedRoomType | BookingChanges | DepositType | Agent | Company | DaysInWaitingList | CustomerType | ADR | RequiredCarParkingSpaces | TotalOfSpecialRequests | ReservationStatus | ReservationStatusDate | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 40050 | 0 | 173 | 2017 | August | 35 | 27 | 4 | 9 | 2 | 0 | 0 | HB | PRT | Offline TA/TO | TA/TO | 0 | 0 | 0 | D | D | 1 | No Deposit | 181 | NULL | 0 | Transient-Party | 168.92 | 0 | 1 | Check-Out | 2017-09-09 |
| 40051 | 0 | 264 | 2017 | August | 34 | 26 | 4 | 10 | 2 | 0 | 0 | BB | NLD | Offline TA/TO | TA/TO | 0 | 0 | 0 | D | D | 2 | No Deposit | 71 | NULL | 0 | Transient | 89.79 | 0 | 0 | Check-Out | 2017-09-09 |
| 40052 | 0 | 207 | 2017 | August | 34 | 26 | 4 | 10 | 2 | 0 | 0 | HB | GBR | Offline TA/TO | TA/TO | 0 | 0 | 0 | E | E | 0 | No Deposit | 143 | NULL | 0 | Transient | 131.70 | 0 | 2 | Check-Out | 2017-09-09 |
| 40053 | 0 | 269 | 2017 | August | 34 | 24 | 4 | 13 | 2 | 0 | 0 | BB | GBR | Offline TA/TO | TA/TO | 0 | 0 | 0 | D | D | 0 | No Deposit | 40 | NULL | 0 | Contract | 84.80 | 0 | 2 | Check-Out | 2017-09-10 |
| 40054 | 0 | 169 | 2017 | August | 35 | 30 | 2 | 9 | 2 | 0 | 0 | BB | IRL | Direct | Direct | 0 | 0 | 0 | E | E | 0 | No Deposit | 250 | NULL | 0 | Transient-Party | 204.27 | 0 | 1 | Check-Out | 2017-09-10 |
| 40055 | 0 | 212 | 2017 | August | 35 | 31 | 2 | 8 | 2 | 1 | 0 | BB | GBR | Offline TA/TO | TA/TO | 0 | 0 | 0 | A | A | 1 | No Deposit | 143 | NULL | 0 | Transient | 89.75 | 0 | 0 | Check-Out | 2017-09-10 |
| 40056 | 0 | 169 | 2017 | August | 35 | 30 | 2 | 9 | 2 | 0 | 0 | BB | IRL | Direct | Direct | 0 | 0 | 0 | E | E | 0 | No Deposit | 250 | NULL | 0 | Transient-Party | 202.27 | 0 | 1 | Check-Out | 2017-09-10 |
| 40057 | 0 | 204 | 2017 | August | 35 | 29 | 4 | 10 | 2 | 0 | 0 | BB | IRL | Direct | Direct | 0 | 0 | 0 | E | E | 0 | No Deposit | 250 | NULL | 0 | Transient | 153.57 | 0 | 3 | Check-Out | 2017-09-12 |
| 40058 | 0 | 211 | 2017 | August | 35 | 31 | 4 | 10 | 2 | 0 | 0 | HB | GBR | Offline TA/TO | TA/TO | 0 | 0 | 0 | D | D | 0 | No Deposit | 40 | NULL | 0 | Contract | 112.80 | 0 | 1 | Check-Out | 2017-09-14 |
| 40059 | 0 | 161 | 2017 | August | 35 | 31 | 4 | 10 | 2 | 0 | 0 | HB | DEU | Offline TA/TO | TA/TO | 0 | 0 | 0 | A | A | 0 | No Deposit | 69 | NULL | 0 | Transient | 99.06 | 0 | 0 | Check-Out | 2017-09-14 |
Most frequently occurring
| IsCanceled | LeadTime | ArrivalDateYear | ArrivalDateMonth | ArrivalDateWeekNumber | ArrivalDateDayOfMonth | StaysInWeekendNights | StaysInWeekNights | Adults | Children | Babies | Meal | Country | MarketSegment | DistributionChannel | IsRepeatedGuest | PreviousCancellations | PreviousBookingsNotCanceled | ReservedRoomType | AssignedRoomType | BookingChanges | DepositType | Agent | Company | DaysInWaitingList | CustomerType | ADR | RequiredCarParkingSpaces | TotalOfSpecialRequests | ReservationStatus | ReservationStatusDate | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1821 | 1 | 92 | 2016 | February | 9 | 26 | 1 | 2 | 2 | 0 | 0 | Undefined | PRT | Groups | TA/TO | 0 | 1 | 0 | A | A | 0 | Non Refund | 134 | NULL | 0 | Transient | 79.00 | 0 | 0 | Canceled | 2015-12-10 | 55 |
| 2221 | 1 | 259 | 2015 | September | 38 | 17 | 0 | 3 | 2 | 0 | 0 | BB | GBR | Groups | Corporate | 0 | 1 | 0 | A | A | 0 | Non Refund | NULL | 223 | 0 | Transient | 40.05 | 0 | 0 | Canceled | 2015-01-21 | 50 |
| 1853 | 1 | 106 | 2016 | March | 13 | 24 | 1 | 3 | 2 | 0 | 0 | FB | PRT | Groups | Direct | 0 | 0 | 0 | A | A | 0 | Non Refund | 68 | NULL | 0 | Transient | 84.00 | 0 | 0 | Canceled | 2016-01-22 | 40 |
| 2220 | 1 | 259 | 2015 | September | 38 | 17 | 0 | 3 | 1 | 0 | 0 | BB | GBR | Groups | Corporate | 0 | 1 | 0 | A | A | 0 | Non Refund | NULL | 223 | 0 | Transient | 33.30 | 0 | 0 | Canceled | 2015-01-21 | 40 |
| 604 | 0 | 40 | 2017 | January | 3 | 16 | 1 | 2 | 1 | 0 | 0 | Undefined | PRT | Groups | Direct | 0 | 0 | 0 | A | A | 0 | No Deposit | NULL | NULL | 0 | Transient-Party | 55.00 | 0 | 0 | Check-Out | 2017-01-19 | 29 |
| 1765 | 1 | 74 | 2016 | February | 9 | 26 | 1 | 2 | 2 | 0 | 0 | Undefined | PRT | Groups | TA/TO | 0 | 0 | 0 | A | A | 0 | Non Refund | 68 | NULL | 0 | Transient | 70.00 | 0 | 0 | Canceled | 2016-01-21 | 29 |
| 1951 | 1 | 140 | 2016 | February | 7 | 12 | 0 | 2 | 2 | 0 | 0 | HB | PRT | Groups | TA/TO | 0 | 0 | 0 | A | A | 0 | Non Refund | NULL | NULL | 0 | Transient | 50.00 | 0 | 0 | Canceled | 2015-12-11 | 29 |
| 1775 | 1 | 78 | 2015 | October | 41 | 9 | 1 | 2 | 2 | 0 | 0 | FB | ESP | Groups | TA/TO | 0 | 0 | 0 | A | A | 0 | Non Refund | 134 | NULL | 0 | Transient | 92.00 | 0 | 0 | Canceled | 2015-08-14 | 28 |
| 2252 | 1 | 277 | 2016 | June | 25 | 12 | 2 | 2 | 2 | 0 | 0 | Undefined | PRT | Groups | TA/TO | 0 | 0 | 0 | A | A | 0 | Non Refund | NULL | NULL | 0 | Transient | 110.00 | 0 | 0 | Canceled | 2016-03-29 | 28 |
| 2317 | 1 | 393 | 2016 | October | 41 | 8 | 2 | 2 | 2 | 0 | 0 | HB | PRT | Groups | TA/TO | 0 | 0 | 0 | A | A | 0 | Non Refund | 68 | NULL | 0 | Transient | 72.00 | 0 | 0 | Canceled | 2015-12-17 | 28 |